/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : desktop

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 29/12/2022 09:08:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for web-type
-- ----------------------------
DROP TABLE IF EXISTS `web-type`;
CREATE TABLE `web-type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of web-type
-- ----------------------------
BEGIN;
INSERT INTO `web-type` VALUES (1, '程序员');
INSERT INTO `web-type` VALUES (2, '设计师');
INSERT INTO `web-type` VALUES (3, '产品经理');
INSERT INTO `web-type` VALUES (4, '运营');
INSERT INTO `web-type` VALUES (5, '人事/财务/行政');
INSERT INTO `web-type` VALUES (6, '销售');
INSERT INTO `web-type` VALUES (7, '传媒');
INSERT INTO `web-type` VALUES (8, '金融');
INSERT INTO `web-type` VALUES (9, '教育培训');
INSERT INTO `web-type` VALUES (10, '医疗健康');
INSERT INTO `web-type` VALUES (11, '旅游');
INSERT INTO `web-type` VALUES (12, '农/林/牧/渔');
INSERT INTO `web-type` VALUES (13, '咨询/翻译/法律');
INSERT INTO `web-type` VALUES (14, '生活');
INSERT INTO `web-type` VALUES (15, '游戏');
INSERT INTO `web-type` VALUES (16, '电商');
COMMIT;

-- ----------------------------
-- Table structure for website
-- ----------------------------
DROP TABLE IF EXISTS `website`;
CREATE TABLE `website` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(10000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `background` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `category` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type_id` int DEFAULT NULL,
  `describe` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of website
-- ----------------------------
BEGIN;
INSERT INTO `website` VALUES (1, '稀土掘金', 'https://juejin.cn/', 'https://is1-ssl.mzstatic.com/image/thumb/Purple112/v4/61/44/c5/6144c5f2-07ec-b7fc-644b-7c4b01f013e3/AppIcon-0-1x_U007emarketing-0-7-0-85-220.png/460x0w.webp', '#FFFFFF', '社区', 1, '掘金是面向全球中文开发者的技术内容分享与交流平台');
INSERT INTO `website` VALUES (2, '电鸭社区', 'https://eleduck.com/', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fpic1.zhimg.com%2Fv2-3bc9193cb086672b1b281f26f62d5ad6_ipico.jpg%3Fsource%3D3af55fa1&refer=http%3A%2F%2Fpic1.zhimg.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1674817332&t=10711421d79ef5fb0e9a65dba3dd1cf2', '#FFFFFF', '社区', 1, '电鸭社区是具有8年历史的远程工作招聘社区，也是远程办公互联网工作者们的聚集地');
INSERT INTO `website` VALUES (3, '思否', 'https://segmentfault.com/', 'https://is2-ssl.mzstatic.com/image/thumb/Purple115/v4/be/c6/d6/bec6d6ac-3360-8a1e-3544-305e2c90a004/AppIcon-1x_U007emarketing-0-6-0-0-85-220.png/350x350.png?', '#FFFFFF', '社区', 1, 'SegmentFault 思否是中国领先的开发者技术社区');
INSERT INTO `website` VALUES (4, '51CTO', 'https://www.51cto.com', 'https://is5-ssl.mzstatic.com/image/thumb/Purple113/v4/21/ea/ed/21eaed51-c90c-429d-20bd-75ac96d11bc7/AppIcon-1x_U007emarketing-0-7-0-0-85-220.png/350x350.png', '#FFFFFF', '社区', 1, '51CTO是中国领先的IT技术在线学习平台和中国最大的IT技术社区之一');
INSERT INTO `website` VALUES (6, 'InfoQ', 'https://www.infoq.cn', 'https://is4-ssl.mzstatic.com/image/thumb/Purple114/v4/52/27/b0/5227b0c4-ea05-98bd-e746-e063fe2d8170/AppIcon-0-0-1x_U007emarketing-0-0-0-7-0-0-sRGB-0-0-0-GLES2_U002c0-512MB-85-220-0-0.png/246x0w.png', '', '社区', 1, 'InfoQ是一个实践驱动、以社区为中心的技术媒体平台');
INSERT INTO `website` VALUES (7, '极客时间', 'https://time.geekbang.org', 'https://is1-ssl.mzstatic.com/image/thumb/Purple122/v4/d4/1e/70/d41e70af-2b3d-522f-e090-9eb25101d521/AppIcon-0-0-1x_U007emarketing-0-0-0-7-0-0-sRGB-0-0-0-GLES2_U002c0-512MB-85-220-0-0.png/350x350.png?', '', '学习', 1, '极客时间是一款由极客邦科技倾力打造的面向IT领域的知识服务产品 ');
INSERT INTO `website` VALUES (8, 'MOOC', 'https://www.icourse163.org', 'https://is5-ssl.mzstatic.com/image/thumb/Purple112/v4/51/8a/3a/518a3a93-c9d6-abc2-145b-0961f1d1a71b/AppIcon-0-0-1x_U007emarketing-0-0-0-7-0-0-sRGB-0-0-0-GLES2_U002c0-512MB-85-220-0-0.png/350x350.png?', '', '学习', 1, '中国大学MOOC(慕课) 是国内优质的中文MOOC学习平台，由爱课程网携手网易云课堂打造');
INSERT INTO `website` VALUES (9, '力扣', 'https://leetcode.cn', 'https://is3-ssl.mzstatic.com/image/thumb/Purple122/v4/73/49/9d/73499d7c-8d1b-aa2c-5d67-8aa8b1e91fa6/AppIcon-0-0-1x_U007emarketing-0-0-0-7-0-0-sRGB-0-0-0-GLES2_U002c0-512MB-85-220-0-0.png/350x350.png?', '', '学习', 1, '力扣提供海量技术面试资源，帮助你高效提升编程技能');
INSERT INTO `website` VALUES (10, 'GitHub', 'https://github.com', 'https://is4-ssl.mzstatic.com/image/thumb/Purple122/v4/f3/01/f2/f301f26d-fe81-18c0-5684-c80369b7d9af/AppIcon-0-1x_U007emarketing-0-7-0-85-220.png/246x0w.png', '', '学习', 1, 'GitHub是一个在线软件源代码托管服务平台，使用Git作为版本控制软件');
INSERT INTO `website` VALUES (11, '慕课网', 'https://www.imooc.com', 'https://is2-ssl.mzstatic.com/image/thumb/Purple122/v4/1b/66/57/1b665751-a2e7-013e-dede-7908f0a22cbe/AppIcon-0-0-1x_U007emarketing-0-0-0-7-0-0-sRGB-0-0-0-GLES2_U002c0-512MB-85-220-0-0.png/350x350.png?', '', '学习', 1, '慕课网（IMOOC）是IT技能学习平台。慕课网(IMOOC)课程涉及JAVA、前端、Python、大数据等60类主流技术语言，覆盖了面试就业、职业成长、自我提升等需求场景，帮助用户实现从技能提升到岗位提升的能力闭环。');
INSERT INTO `website` VALUES (12, 'GoCn', 'https://gocn.vip', 'https://tvax4.sinaimg.cn/crop.0.0.1080.1080.180/bf670632ly8gc3an8dqg2j20u00u0dgo.jpg?KID=imgbed,tva&Expires=1672157300&ssig=Vfw%2FZzfyAh', '', '社区', 1, 'GoCN是中国最专业&最具影响力的Go技术社区');
INSERT INTO `website` VALUES (13, '开源中国', 'https://www.oschina.net', 'https://is1-ssl.mzstatic.com/image/thumb/Purple113/v4/cb/69/4c/cb694c0e-624a-eea0-5551-36ddb0d82cec/AppIcon-0-0-1x_U007emarketing-0-0-0-5-0-0-85-220.png/246x0w.png', '', '社区', 1, '目前领先的中文开源技术社区。我们传播开源的理念,推广开源项目,为 IT 开发者提供了一个发现、使用、并交流开源技术的平台');
INSERT INTO `website` VALUES (14, '网易云课堂', 'https://study.163.com', 'https://is5-ssl.mzstatic.com/image/thumb/Purple123/v4/27/0b/3a/270b3a24-2973-60c2-9ca5-e2a03073b990/AppIcon-0-0-1x_U007emarketing-0-0-0-7-0-0-sRGB-0-0-0-GLES2_U002c0-512MB-85-220-0-0.png/246x0w.png', '', '学习', 1, '网易云课堂,一个专注于成人终身学习的在线教育平台。立足于实用性的要求, 与优质的教育内容创作者一起,为您提供全面、有效的在线学习内容');
INSERT INTO `website` VALUES (15, '博客园', 'https://www.cnblogs.com', 'https://is3-ssl.mzstatic.com/image/thumb/Purple113/v4/77/fd/cc/77fdccb0-985c-8239-f177-fd3d3e663893/AppIcon-0-1x_U007emarketing-0-7-0-0-85-220.png/246x0w.png', '', '社区', 1, '博客园是一个面向开发者的知识分享社区');
INSERT INTO `website` VALUES (16, 'stackoverflow', 'https://stackoverflow.com', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fpic4.zhimg.com%2F50%2Fv2-2d47e939feed796bcf7483d306661c88_bh.jpg&refer=http%3A%2F%2Fpic4.zhimg.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1674815551&t=af4a25a8e2e7c223d0b1b554a96743d3', '', '社区', 1, '全球最大的技术问答社区');
INSERT INTO `website` VALUES (17, 'B站', 'https://www.bilibili.com', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fapp-center.cdn.bcebos.com%2Fappcenter%2Ffile%2Fupload%2F12dd0465fc9745d49fc94150cad84a71d2c640a8-eb09-4f52-bfca-54fa4bad909c.png&refer=http%3A%2F%2Fapp-center.cdn.bcebos.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=auto?sec=1674816051&t=5dba3f5b08f2948bbdb56328f18312ae', '', '学习', 1, '哔哩哔哩');
INSERT INTO `website` VALUES (18, '牛客', 'https://www.nowcoder.com', 'https://is4-ssl.mzstatic.com/image/thumb/Purple113/v4/13/b2/bd/13b2bda3-372b-07b4-2466-17799df7a40a/AppIcon-0-0-1x_U007emarketing-0-0-0-7-0-0-sRGB-0-0-0-GLES2_U002c0-512MB-85-220-0-0.png/246x0w.png', '', '学习', 1, '牛客网，是一个集笔面试系统、题库、课程教育、社群交流、招聘内推于一体的招聘类网站');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
